USE [vudu]
GO
CREATE PROCEDURE [dbo].[ConsultarCorreoRol]
@correo varchar(50)
AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT id_rol
	  FROM ROL
	 WHERE correo = @correo;
END;

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO